Multidimensional Databases
نویسندگان
چکیده
Multidimensional databases is a key technology in the enabling of interactive analyses of large amounts of data for decision-making purposes. Multidimensional databases differ from previous technologies by viewing data specifically as multidimensional cubes, which have proven to be particularly well suited for data analyses. Multidimensional models more specifically categorize data as either facts—which are the entities of interest w.r.t. the analyses at hand, e.g., a purchase in a retail business—or dimensions, which are mostly textual and characterize the facts, e.g., the location of the purchase, the product being purchased, and the time of the purchase. Facts have associated numerical measures that capture the properties of the facts that are to be studied, e.g., the total sales price. This article describes multidimensional concepts such as cubes, facts, dimensions, measures, and querying, including advanced issues, and it introduces implementation techniques such as MOLAP, ROLAP, and pre-aggregation.
منابع مشابه
Multidimensional Database Representation of Real-time, Volatile, and Multi-behavioral Environments
Traditional relational and multidimensional databases are poorly equipped to deal with data collected from dynamic and volatile environments, where characteristics and conditions are erratic or goals of the system could alter rapidly. These databases’ data models of real-world objects require human involvement for creation and modification, since neither relational nor multidimensional database...
متن کاملPattern Recognition Approach in Multidimensional Databases: Application to the Global Terrorism Database
This paper presents a pattern recognition approach in multidimensional databases. The approach is based on a clustering method using the distance measurement between a reference profile and the database observations. Two distance measurements will be proposed: an adaptation of the Khi formula to the multidimensional context, extracted from the Multiple Correspondence Analysis (MCA), and the Euc...
متن کاملA Logical Framework for Querying
We address the issue of designing e ective query languages for OLAP databases. The basis of our investigation is MD, a logical data model for multidimensional databases that, unlike other multidimensional models, is independent of any speci c implementation. As such, MD provides a clear separation between practical and conceptual aspects of multidimensional analysis. In this framework, we prese...
متن کاملThe Power of Hybrid OLAP in a Multidimensional World
Version 8 of the SAS® System brings powerful new features for managing a Hybrid OLAP (HOLAP) or Distributed Multidimensional Data environment. The HOLAP component of the SAS/MDDB® Server software enables you to include SAS Multidimensional databases (MDDB), SAS files, and relational (RDBMS) databases into a single, powerful OLAP reporting environment. Support for HOLAP data groups is fully inte...
متن کاملIncomplete Information in Multidimensional Databases
Copyright © 2003, Idea Group Inc. Copying or distributing in print or electronic forms without written permission of Idea Group Inc. is prohibited. ABSTRACT While incomplete information is endemic to real-world data, current multidimensional data models are not engineered to manage incomplete information in base data, derived data, and dimensions. This chapter presents several strategies for ma...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2005